/*
 * @Description:
 * @Author: 崔堂袁
 * @Date: 2021-04-24 22:58:44
 * @LastEditTime: 2021-05-11 11:37:36
 */
// sql语句
var sqlMap = {
  user: {
    // 添加用户
    add: 'insert into user (account, password) value (?, ?)',
    // 查询用户
    find: 'select * from user where account = ?',
    // 更新用户名
    updateUserName: 'update user set userName = ? where account = ?',
    // 修改密码
    updatePassword: 'update user set passWord = ? where account = ?'
  },
  userData: {
    add: 'insert into programs (userAccount, programName, strScene, strPhoto) value (?, ?, ?, ?)',
    find: 'select * from programs where userAccount = ?',
    update: 'update programs set strScene = ?, strPhoto = ? where userAccount = ? and programName = ?',
    delete: 'delete from programs where userAccount = ? and programName = ?',
    findIsSameName: 'select * from programs where userAccount = ? and programName = ?'
  }
}

module.exports = sqlMap
